what about this?
DECLARE @InputString NVARCHAR(MAX)
DECLARE @Delimiter NVARCHAR(40)
DECLARE @Pos INT
DECLARE @NextPos INT
DECLARE @NextString NVARCHAR(40)
SET @InputString = 'hello,its,a,beautiful,day'
SET @Delimiter = ','
SET @Pos = charindex(@Delimiter,@InputString)
SET @InputString = @InputString + @Delimiter
CREATE TABLE #Results(Tokens NVARCHAR(MAX))
WHILE (@pos <> 0)
BEGIN
SET @NextString = substring(@InputString,1,@Pos - 1)
INSERT INTO #Results VALUES (@NextString)
SET @InputString = substring(@InputString,@pos+1,len(@InputString))
SET @pos = charindex(@Delimiter,@InputString)
END
SELECT * FROM #Results
DROP TABLE #Results